UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/QUib8sMJ0CodUQlVahpX3xvSXzMZWRQZRXf/Co6A58='
WHERE
key_id = 'a0cd8a611fdb5d8f1b6f244341a0140d6d1c87a8257a5c1c159b5a63c8d98107'
AND (
token = '/QUib8sMJ0CodUQlVahpX3xvSXzMZWRQZRXf/Co6A58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)