UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IGKGOtpGABCGHo0dUXxfo2YhxAJwAHmi5S2xbHwPskA='
WHERE
key_id = '572d831ce0fdba65725b675b3a0caa316175bc3d80ea42c7bb0ddfcf09186987'
AND (
token = 'IGKGOtpGABCGHo0dUXxfo2YhxAJwAHmi5S2xbHwPskA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)