UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D0oOEZoUI3hK1wupAPYutcXyNfSXnyw/62lBEwb9tCI='
WHERE
key_id = 'c04018d3ed18f0bc9170da6d728e4abb4e1e52fede5c0c3acc13e4e4832ad730'
AND (
token = 'D0oOEZoUI3hK1wupAPYutcXyNfSXnyw/62lBEwb9tCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)