UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XiZJJjNYcpmL929G9al1TR0UO0hEu0NQcB1jb+5sN+Y='
WHERE
key_id = '9f0bb4463fa1c584c29bac134c34b7f1a1a849ba5eba326e6961d3acb1860fee'
AND (
token = 'XiZJJjNYcpmL929G9al1TR0UO0hEu0NQcB1jb+5sN+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)