UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WE79afNC5RyLSbOc7h16t/ur5O6uuV1bfLu/lx7eFNo='
WHERE
key_id = '7844c7df7ce73b88acbfd3e46aafbf1ccaa9ed922b454c404966eacd28724b7b'
AND (
token = 'WE79afNC5RyLSbOc7h16t/ur5O6uuV1bfLu/lx7eFNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)