UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M5sKqm8YvnyYdAYifuSxcEFMAXSSSlm4dr6o1m40DHw='
WHERE
key_id = '5bc5597a02704839008497602ec83c14758f4652c5649bbd9b2a23bb1a41a022'
AND (
token = 'M5sKqm8YvnyYdAYifuSxcEFMAXSSSlm4dr6o1m40DHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)