UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7xblQDmfiiwjhQYFBhtqV1jS5sSQ3lO1zJZGWdCae8='
WHERE
key_id = '2f130e7bc18fa40ab008774459e1bc01c69752b5c0f19645843434cd536cefe4'
AND (
token = 'a7xblQDmfiiwjhQYFBhtqV1jS5sSQ3lO1zJZGWdCae8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)