UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEfRkLChCIOuAGW9ebDnpJKUmzOM4M8Z1nnoNy+7f9A='
WHERE
key_id = 'edfed982862c576b0466669321e718968d14ee69639997f2f6d2d180861ec434'
AND (
token = 'zEfRkLChCIOuAGW9ebDnpJKUmzOM4M8Z1nnoNy+7f9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)