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