UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TWy52DNp+0hyi/yRiUa5TJAvEOtMAZvDs/3LGIvy9n8='
WHERE
key_id = 'abd69740e77f61ddd04cea06532ac9e63c0392faecd8673736be409050fea33e'
AND (
token = 'TWy52DNp+0hyi/yRiUa5TJAvEOtMAZvDs/3LGIvy9n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)