UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BacpWQC494hQy8OZ1U7LdGMJ+8GGM446umrjw+riA0Q='
WHERE
key_id = '4f3e5924f0b702ac7cd3decef8b8932f7165eb2d909e7c93f0602b4d3fe6c293'
AND (
token = 'BacpWQC494hQy8OZ1U7LdGMJ+8GGM446umrjw+riA0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)