UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BP27eIKym8+wxxctLhT59H2tLj12cJ47UdYhmRWFSMs='
WHERE
key_id = 'b40cd7a9ea9754a1a27514e6f309d2bcfa91f32f539c46cc039c2f9c97adf0b7'
AND (
token = 'BP27eIKym8+wxxctLhT59H2tLj12cJ47UdYhmRWFSMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)