UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BRksVwRtWDK4BUn7BX5FZtuvYg2MrtZCILVpZymYeCg='
WHERE
key_id = 'd930667c1db35b522f1321ab77498248127231323c2febccc9c8f5487cd15a3a'
AND (
token = 'BRksVwRtWDK4BUn7BX5FZtuvYg2MrtZCILVpZymYeCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)