UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNFjlLU2Nmz48YZxHzB95Gd9oQDWnexF63wOboccg/o='
WHERE
key_id = 'c12d8157ce0dfec5952b51740fa11a9ccabb0797a6b24af628341e8e67732e14'
AND (
token = 'GNFjlLU2Nmz48YZxHzB95Gd9oQDWnexF63wOboccg/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)