UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVisdt4zNwonWtIFCqK6TQJWB0BacsiAJzwVtW8C7OQ='
WHERE
key_id = 'b25bedc6a7e7f185fe168094ddd0d058fa7b685b8525de337519bebaf22cf449'
AND (
token = 'pVisdt4zNwonWtIFCqK6TQJWB0BacsiAJzwVtW8C7OQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)