UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gXBjAg6/LLgmfgH6A22gLy4Xg6bzSp6CVRjRIXi5r0='
WHERE
key_id = '3bc31c597281962a2ed0deee627f302429f109e27e3762835756b2b9458aab0d'
AND (
token = '6gXBjAg6/LLgmfgH6A22gLy4Xg6bzSp6CVRjRIXi5r0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)