UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hka+ogjHFwDTq+hj7o3yRMUVLmVnwdusR4TC7bre3QI='
WHERE
key_id = 'd834742bbcbc4aefb35b06374d8daf58a0fb8b493aa226f9d0117729479a7dde'
AND (
token = 'Hka+ogjHFwDTq+hj7o3yRMUVLmVnwdusR4TC7bre3QI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)