UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tyYkJbUC0dj312s/kUDX3u4tIsf4aMhhjX+tT4pm0Os='
WHERE
key_id = 'a566d412692b28d2675ad77c45c2f62b67e0fc9990fca02f18face4d10ca1129'
AND (
token = 'tyYkJbUC0dj312s/kUDX3u4tIsf4aMhhjX+tT4pm0Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)