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