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