UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZnDuqjNCEfBzzgE7VZFL+9UwpAfqv5cNSpYUZCYdhc='
WHERE
key_id = '1e7304f7b7a9d5165b959479965668e26684641771a5fb383b034b06a94ae5da'
AND (
token = 'BZnDuqjNCEfBzzgE7VZFL+9UwpAfqv5cNSpYUZCYdhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)