UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WTxrI7OaDc2n0bfDfgUEpOWtlMLCSCSGHU6VUK/QYPg='
WHERE
key_id = '7f19134b4115edc0b5f98c28796da2fa0a7331fa968773d7df9c1d56010989f4'
AND (
token = 'WTxrI7OaDc2n0bfDfgUEpOWtlMLCSCSGHU6VUK/QYPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)