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