UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lp13ffE5X9mYvcUuylxW3HO4ASMAJR1jR8LpY6iCliw='
WHERE
key_id = '512f9136b282e1cc58276587ec440052cbc213979be93085b3ff2de7940ba042'
AND (
token = 'Lp13ffE5X9mYvcUuylxW3HO4ASMAJR1jR8LpY6iCliw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)