UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ypwVGlOHY1VmWX1SsVNG2PgqWw0IKib+WhFLtHX+RCg='
WHERE
key_id = '141ca97729a12bb0412749d31daae57846ee77355a752a6c1518081f539a14aa'
AND (
token = 'ypwVGlOHY1VmWX1SsVNG2PgqWw0IKib+WhFLtHX+RCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)