UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'emo2Q+v9z7+QMjp1daSkLFCoDvnIm0OPgabZqfCr5xw='
WHERE
key_id = 'baf39787ce0c1f90c3b6456cfe346e59e0ffc4767cded4de1b7d0342be194c5d'
AND (
token = 'emo2Q+v9z7+QMjp1daSkLFCoDvnIm0OPgabZqfCr5xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)